<?php
//共246个国家地区
include("./dbconnect.php");
$file = fopen("./country_codes_and_numeric.txt","r");
while(! feof($file))
{
	$one_line = fgets($file);
	$array_1 = explode(';',$one_line);
	$sql = "INSERT INTO `country` (`id`,`code`) VALUES('".$array_1[0]."','".$array_1[2]."')";
	$dbh->query($sql);
	$sql_2 = "INSERT INTO `country_name_translation` (`country_id`,`en-US`) VALUES('".$array_1[0]."','".$array_1[1]."')";
	$dbh->query($sql_2);
}
$dbh = null;
fclose($file);
//384 408 418无法批量写入country_name_translation，可以手动补充
?>